#region Using directives
using System;
using System.Collections;
	
using System.Data ;
using WP.DB;
using WP.MF.DataEntity; 
using WP.Commons;
#endregion

namespace WP.MF.DataAccess
{

    public class MRemitToDAL : IDataAccess
	{
		public MRemitToDAL()
		{}

        #region Select List
        public string SQLList(int iParameter)
        {
            string strSQL = @"select RecId, RemitToNo,CompanyName,Street,City,ProvNo,PostalCode from mRemitTo order by RemitToNo ";
            return strSQL;
        }
        #endregion

		#region Fields
        public string Fields
		{
			get
			{
				return @"RemitToNO,Street,City,ProvNo,PostalCode,CompanyName";
			}
		}
		#endregion

		#region SelectMRemitToForList()
		/// <summary>
		/// Get remitto info with a dropdownlist control
		/// </summary>
		/// <param name="dBAccess"></param>
		/// <returns></returns>
		public DataView SelectMRemitToForList(DBAccess dBAccess)
		{
			string strSql="";
			strSql="select RemitToNo,CompanyName,Street,City,ProvNo,PostalCode from mRemitTo Order by RemitToNo";
			
			return dBAccess.GetDataSet(strSql).Tables[MRemitToDEL.TABLENAME_MREMITTO].DefaultView;

		}
		#endregion

	}
}
